/*
 * @(#) test
 *
 * <br> Copyright:  Copyright (c) 2017
 * <br> @author caijinhuang
 * <br> 2017-12-19 10:03:01
 */

package poitest;

import org.junit.Test;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.List;

public class test {
    @Test
    public void importExcelTest() throws Exception {
        File file = new File("D:\\用户信息采集表.xlsx");
        InputStream inputStream = new FileInputStream(file);
        ImportExcelUtil importExcelUtil = new ImportExcelUtil();
        List<List<Object>> fileList = importExcelUtil.getBankListByExcel(inputStream,"D：\\用户信息采集表.xlsx","用户信息");
        for(List list:fileList){
            System.out.println(list);
        }
    }
}
